package com.example.superoa.model.mappers;

import java.util.Date;

import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;

import com.alibaba.fastjson.JSONArray;
import com.alibaba.fastjson.JSONObject;
import com.example.superoa.model.pojos.Course;

@Mapper
public interface TrainMapper {
 public void deleteCourse(@Param("course_id")Integer course_id,
		 @Param("teacher_id")Integer teacher_id);
 public void addCourse(@Param("course_id")Integer course_id,
		 @Param("teacher_id")Integer teacher_id);
 public JSONArray findTeacherByName();
 public JSONArray findShijuan();
 public JSONArray findCourse();
 public JSONArray findTeachers();
 public JSONArray findTeacher();
 public JSONArray findCourseku();
 public JSONArray findCoursekuBytype();
 public JSONArray findRecord();
 public JSONArray findCoursekuById(@Param("course_id")Integer course_id);//通过课程id查询课程详情
 public void insertActivity(@Param("activityid")Integer activityid,@Param("staffid")Integer staffid);
 public JSONArray findActStaff(@Param("activity_id")Integer activity_id); 
 public int selectLimitOne();
 public int selectActOne();
 public JSONArray sjcsh(@Param("course_id")int course_id);
 public void xiugai(@Param("teacher_id")int teacher_id,@Param("course_id")int course_id);
 public void shanchuact(@Param("activity_id")int activity_id);
 public JSONArray noticefind();
 public JSONArray findntchakan(@Param("activity_id")int activity_id);
 public JSONArray findnttable(@Param("activity_id")int activity_id);
 public JSONArray findrecords();
 public JSONArray findtea();
 public JSONArray findapp();
 public Integer apply_id();
 public void deleteactstaff(@Param("activity_id")int activity_id,@Param("staff_id")int staff_id);
 public JSONArray findrecordact();
 public void huo_yuan_deleted(@Param("activity_id")int activity_id);
 public JSONArray findstaffde(int staff_id);
 public JSONArray finddeleteapp(Integer apply_id);
 public JSONArray applyxq(int apply_id);
 public JSONArray noticestaff(@Param("staff_id")Integer staff_id,@Param("shijian")Date shijian);
 public JSONObject departsid(@Param("staff_id")int staff_id);
}
